-------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  /Users/yannakrupnikov/Dropbox/Turnover2/Updated Data and Do File/Replication Materials Final/Replication Main Text
>  DONE/Table_2.log
  log type:  text
 opened on:  22 Feb 2018, 14:32:26

. do "/var/folders/6_/whs9p_gd7k1gzplfk07y_0vr0000gn/T//SD47713.000000"

. **Table 2**
. use "main.dta"

. 
. **points of prof based on median splits -- as text explains, professionalism is dichotomized for this test alone
. **producing the percentages
. su pctelect if ambiguity==1 // produces unbalanced + low prof

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
    pctelect |        329    27.76292    13.71732          0         82

. su pctelect if ambiguity==2 //produces balanced + low prof

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
    pctelect |         94    26.90877    10.68485   2.857143   52.63158

. su pctelect if ambiguity==3 // produces balanced + high prof

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
    pctelect |         59    23.02623    11.59978   .0150001     49.855

. su pctelect if ambiguity==4 //produces unbalanced + high prof

    Variable |        Obs        Mean    Std. Dev.       Min        Max
-------------+---------------------------------------------------------
    pctelect |        405    25.57427      13.377          0         70

. 
. 
. **Significance comparisons [note in-text differences vary slighty due to rounding] 
. ttest pctelect if (ambiguity==2|ambiguity==3), by(ambiguity) // produces difference between high ambiguity and balance/low

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. Err.   Std. Dev.   [95% Conf. Interval]
---------+--------------------------------------------------------------------
       2 |      94    26.90877    1.102058    10.68485     24.7203    29.09724
       3 |      59    23.02623    1.510162    11.59978    20.00332    26.04915
---------+--------------------------------------------------------------------
combined |     153    25.41158    .9031161    11.17093     23.6273    27.19587
---------+--------------------------------------------------------------------
    diff |            3.882537    1.834557                .2578218    7.507253
------------------------------------------------------------------------------
    diff = mean(2) - mean(3)                                      t =   2.1163
Ho: diff = 0                                     degrees of freedom =      151

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.9820         Pr(|T| > |t|) = 0.0360          Pr(T > t) = 0.0180

. ttest pctelect if (ambiguity==1|ambiguity==3), by(ambiguity) // produces difference between high ambiguity and unbalanced/low

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. Err.   Std. Dev.   [95% Conf. Interval]
---------+--------------------------------------------------------------------
       1 |     329    27.76292    .7562604    13.71732    26.27519    29.25065
       3 |      59    23.02623    1.510162    11.59978    20.00332    26.04915
---------+--------------------------------------------------------------------
combined |     388    27.04265    .6859121     13.5109    25.69407    28.39123
---------+--------------------------------------------------------------------
    diff |            4.736686    1.897406                1.006142     8.46723
------------------------------------------------------------------------------
    diff = mean(1) - mean(3)                                      t =   2.4964
Ho: diff = 0                                     degrees of freedom =      386

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.9935         Pr(|T| > |t|) = 0.0130          Pr(T > t) = 0.0065

. ttest pctelect if (ambiguity==4|ambiguity==3), by(ambiguity) // produces difference between high ambiguity and unbalanced/hig
> h 

Two-sample t test with equal variances
------------------------------------------------------------------------------
   Group |     Obs        Mean    Std. Err.   Std. Dev.   [95% Conf. Interval]
---------+--------------------------------------------------------------------
       3 |      59    23.02623    1.510162    11.59978    20.00332    26.04915
       4 |     405    25.57427    .6647086      13.377    24.26755    26.88099
---------+--------------------------------------------------------------------
combined |     464    25.25028    .6118781    13.18026    24.04787    26.45268
---------+--------------------------------------------------------------------
    diff |           -2.548038    1.834824               -6.153672    1.057596
------------------------------------------------------------------------------
    diff = mean(3) - mean(4)                                      t =  -1.3887
Ho: diff = 0                                     degrees of freedom =      462

    Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = 0.0828         Pr(|T| > |t|) = 0.1656          Pr(T > t) = 0.9172

. 
end of do-file

. log close
      name:  <unnamed>
       log:  /Users/yannakrupnikov/Dropbox/Turnover2/Updated Data and Do File/Replication Materials Final/Replication Main Text
>  DONE/Table_2.log
  log type:  text
 closed on:  22 Feb 2018, 14:32:43
-------------------------------------------------------------------------------------------------------------------------------
